package jpa.entitys.synchro.staging;

import java.io.Serializable;

import javax.persistence.*;

import java.util.Date;


/**
 * The persistent class for the FI_ARINVOICERECE_OUTB database table.
 * 
 */
@Entity
@Table(name="FI_ARINVOICERECE_OUTB")
@NamedQueries({
    @NamedQuery(name = "FiArinvoicereceOutb.findAll", query = " SELECT c FROM FiArinvoicereceOutb c "),
    @NamedQuery(name = "FiArinvoicereceOutb.findById", query = " SELECT c FROM FiArinvoicereceOutb c WHERE  c.promisStagingId = :Id "),
    @NamedQuery(name = "FiArinvoicereceOutb.findByInstanceNo", query = " SELECT c FROM FiArinvoicereceOutb c WHERE  c.instanceNo = :instanceNo And c.issync = 'N' order by c.company,c.project,c.receiptDocNo,c.promisStagingId asc"),
    @NamedQuery(name = "FiArinvoicereceOutb.findIsSync", query = " SELECT c FROM FiArinvoicereceOutb c WHERE  c.issync = :issync  order by c.instanceNo asc"),
    })
public class FiArinvoicereceOutb extends jpa.entitys.synchro.common.CommonEntity implements Serializable {
	private static final long serialVersionUID = 1L;

	@Id
	@Column(name="PROMIS_STAGING_ID", unique=true, nullable=false, length=100)
	private String promisStagingId;
	
	@Override public String toString() { return org.apache.commons.lang.builder.ToStringBuilder.reflectionToString(this);}

	@Column(name="ACTION_HANDLER", length=20)
	private String actionHandler;

	@Column(name="ADDRESS_CUSTOMER", length=300)
	private String addressCustomer;

	@Column(name="AMOUNT_RECEIVED", length=30)
	private String amountReceived;

	@Column(name="BANK_CHARGE", length=30)
	private String bankCharge;

	@Column(name="CHARGE_CODE", length=10)
	private String chargeCode;

	@Column(name="CHEQUE_AMOUNT", length=30)
	private String chequeAmount;

	@Column(name="CHEQUE_DUE_DATE", length=30)
	private String chequeDueDate;

	@Column(name="CHEQUE_ISSUING_BANK", length=300)
	private String chequeIssuingBank;

	@Column(name="CHEQUE_NUMBER", length=100)
	private String chequeNumber;

	@Column(name="CHEQUE_PAYEE_AC", length=30)
	private String chequePayeeAc;

	@Column(name="CHEQUE_PAYER_AC_NO", length=100)
	private String chequePayerAcNo;

	@Column(length=100)
	private String company;

	@Column(name="COMPANY_ADDRESS", length=2000)
	private String companyAddress;

	@Column(name="CREATED_BY", length=30)
	private String createdBy;

	@Column(name="CREATED_ON", length=20)
	private String createdOn;

	@Column(length=10)
	private String currency;

	@Column(name="CUSTOMER_CODE", length=30)
	private String customerCode;

	@Column(length=4000)
	private String description;

	@Column(name="EXCHANGE_RATE", length=30)
	private String exchangeRate;

	@Column(name="EXT_REF_KEY", length=100)
	private String extRefKey;

	@Column(name="EXT_REF_NO", length=100)
	private String extRefNo;

	@Column(name="FULL_PARTIAL_FLAG", length=10)
	private String fullPartialFlag;

	@Column(name="INSTANCE_NO", length=100)
	private String instanceNo;

	@Column(name="INVOICE_REF_DATE", length=10)
	private String invoiceRefDate;

	@Column(name="INVOICE_REF_NO", length=100)
	private String invoiceRefNo;

	@Column(length=1)
	private String isactive;

	@Column(length=1)
	private String issync;

	@Column(name="MSG_ACT_RESULT", length=3707)
	private String msgActResult;

	@Column(name="MSG_ALT_DESC", length=3700)
	private String msgAltDesc;

	@Column(name="MSG_CODE", length=1500)
	private String msgCode;

	@Column(name="MSG_DESC", length=3700)
	private String msgDesc;

	@Column(name="CUSTOMER_NAME", length=300)
	private String customerName;

	@Column(length=30)
	private String project;

	@Column(name="RECEIPT_DOC_NO", length=100)
	private String receiptDocNo;

	@Column(name="RECEIVED_TYPE", length=10)
	private String receivedType;

	@Column(name="REF_DOCUMENT", length=100)
	private String refDocument;

	@Column(length=4000)
	private String remarks;

	@Column(name="SAP_COMPANY_CODE", length=4)
	private String sapCompanyCode;

	@Column(name="SAP_PLANT_CODE", length=4)
	private String sapPlantCode;

	@Column(name="SERVICE_VAT_FLAG", length=10)
	private String serviceVatFlag;

	@Column(name="SYNC_CREATEDBY", length=100)
	private String syncCreatedby;

    @Temporal( TemporalType.TIMESTAMP)
	@Column(name="SYNC_CREATEDON")
	private Date syncCreatedon;

	@Column(name="SYNC_UPDATEDBY", length=100)
	private String syncUpdatedby;

    @Temporal( TemporalType.TIMESTAMP)
	@Column(name="SYNC_UPDATEDON")
	private Date syncUpdatedon;

	@Column(name="TAX_TYPE_CODE", length=10)
	private String taxTypeCode;

	@Column(name="UNIT_NUMBER", length=30)
	private String unitNumber;

	@Column(name="UPDATED_BY", length=30)
	private String updatedBy;

	@Column(name="UPDATED_ON", length=20)
	private String updatedOn;

	@Column(name="VAT_BASE_RECEIVED", length=30)
	private String vatBaseReceived;

	@Column(name="VAT_CODE", length=30)
	private String vatCode;

	@Column(name="VAT_RECEIVED", length=30)
	private String vatReceived;

	@Column(name="VOUCHER_DATE", length=10)
	private String voucherDate;

	@Column(name="WHT_AMOUNT", length=30)
	private String whtAmount;

	@Column(name="WHT_BASE_AMOUNT", length=30)
	private String whtBaseAmount;
	
	@Column(name="CARD_NO", length=100)
	private String cardNo;

	@Column(name="BANK_CARD_READER", length=100)
	private String bankCardReader;
	
	@Column(name="CREDIT_CARD_TYPE", length=100)
	private String creditCardType;
	
	@Column(name="REF_SYNC_PK_ID", length=100)
	private String refSyncPkId;
	
	@Column(name="STATUS", length=100)
	private String status;
	
	@Column(name="INTERFACE_NO", length=100)
	private String interfaceNo;

	@Column(name="INV_SAP_DATE", length=100)
	private String invSapDate;
	
	@Column(name="INV_SAPNO", length=100)
	private String invSApNo;
	
	@Column(name="ADV_RECEIPT_NO")
	private String advReceiptNo;
	
	@Column(name="RENT_ADV_CLR_ONLY")
	private String rentAdvClrOnly;
	
    public String getRentAdvClrOnly() {
		return rentAdvClrOnly;
	}

	public void setRentAdvClrOnly(String rentAdvClrOnly) {
		this.rentAdvClrOnly = rentAdvClrOnly;
	}

	public String getAdvReceiptNo() {
		return advReceiptNo;
	}

	public void setAdvReceiptNo(String advReceiptNo) {
		this.advReceiptNo = advReceiptNo;
	}

	/**
	 * @return the invSapDate
	 */
	public String getInvSapDate() {
		return invSapDate;
	}

	/**
	 * @param invSapDate the invSapDate to set
	 */
	public void setInvSapDate(String invSapDate) {
		this.invSapDate = invSapDate;
	}

	/**
	 * @return the invSApNo
	 */
	public String getInvSApNo() {
		return invSApNo;
	}

	/**
	 * @param invSApNo the invSApNo to set
	 */
	public void setInvSApNo(String invSApNo) {
		this.invSApNo = invSApNo;
	}

	/**
	 * @return the interfaceNo
	 */
	public String getInterfaceNo() {
		return interfaceNo;
	}

	/**
	 * @param interfaceNo the interfaceNo to set
	 */
	public void setInterfaceNo(String interfaceNo) {
		this.interfaceNo = interfaceNo;
	}

	/**
	 * @return the status
	 */
	public String getStatus() {
		return status;
	}

	/**
	 * @param status the status to set
	 */
	public void setStatus(String status) {
		this.status = status;
	}

	/**
	 * @return the refSyncPkId
	 */
	public String getRefSyncPkId() {
		return refSyncPkId;
	}

	/**
	 * @param refSyncPkId the refSyncPkId to set
	 */
	public void setRefSyncPkId(String refSyncPkId) {
		this.refSyncPkId = refSyncPkId;
	}

	/**
	 * @return the cardNo
	 */
	public String getCardNo() {
		return cardNo;
	}

	/**
	 * @param cardNo the cardNo to set
	 */
	public void setCardNo(String cardNo) {
		this.cardNo = cardNo;
	}

	/**
	 * @return the bankCardReader
	 */
	public String getBankCardReader() {
		return bankCardReader;
	}

	/**
	 * @param bankCardReader the bankCardReader to set
	 */
	public void setBankCardReader(String bankCardReader) {
		this.bankCardReader = bankCardReader;
	}

	/**
	 * @return the creditCardType
	 */
	public String getCreditCardType() {
		return creditCardType;
	}

	/**
	 * @param creditCardType the creditCardType to set
	 */
	public void setCreditCardType(String creditCardType) {
		this.creditCardType = creditCardType;
	}

	public FiArinvoicereceOutb() {
    }

	public String getPromisStagingId() {
		return this.promisStagingId;
	}

	public void setPromisStagingId(String promisStagingId) {
		this.promisStagingId = promisStagingId;
	}

	public String getActionHandler() {
		return this.actionHandler;
	}

	public void setActionHandler(String actionHandler) {
		this.actionHandler = actionHandler;
	}

	public String getAddressCustomer() {
		return this.addressCustomer;
	}

	public void setAddressCustomer(String addressCustomer) {
		this.addressCustomer = addressCustomer;
	}

	public String getAmountReceived() {
		return this.amountReceived;
	}

	public void setAmountReceived(String amountReceived) {
		this.amountReceived = amountReceived;
	}

	public String getBankCharge() {
		return this.bankCharge;
	}

	public void setBankCharge(String bankCharge) {
		this.bankCharge = bankCharge;
	}

	public String getChargeCode() {
		return this.chargeCode;
	}

	public void setChargeCode(String chargeCode) {
		this.chargeCode = chargeCode;
	}

	public String getChequeAmount() {
		return this.chequeAmount;
	}

	public void setChequeAmount(String chequeAmount) {
		this.chequeAmount = chequeAmount;
	}

	public String getChequeDueDate() {
		return this.chequeDueDate;
	}

	public void setChequeDueDate(String chequeDueDate) {
		this.chequeDueDate = chequeDueDate;
	}

	public String getChequeIssuingBank() {
		return this.chequeIssuingBank;
	}

	public void setChequeIssuingBank(String chequeIssuingBank) {
		this.chequeIssuingBank = chequeIssuingBank;
	}

	public String getChequeNumber() {
		return this.chequeNumber;
	}

	public void setChequeNumber(String chequeNumber) {
		this.chequeNumber = chequeNumber;
	}

	public String getChequePayeeAc() {
		return this.chequePayeeAc;
	}

	public void setChequePayeeAc(String chequePayeeAc) {
		this.chequePayeeAc = chequePayeeAc;
	}

	public String getChequePayerAcNo() {
		return this.chequePayerAcNo;
	}

	public void setChequePayerAcNo(String chequePayerAcNo) {
		this.chequePayerAcNo = chequePayerAcNo;
	}

	public String getCompany() {
		return this.company;
	}

	public void setCompany(String company) {
		this.company = company;
	}

	public String getCompanyAddress() {
		return this.companyAddress;
	}

	public void setCompanyAddress(String companyAddress) {
		this.companyAddress = companyAddress;
	}

	public String getCreatedBy() {
		return this.createdBy;
	}

	public void setCreatedBy(String createdBy) {
		this.createdBy = createdBy;
	}

	public String getCreatedOn() {
		return this.createdOn;
	}

	public void setCreatedOn(String createdOn) {
		this.createdOn = createdOn;
	}

	public String getCurrency() {
		return this.currency;
	}

	public void setCurrency(String currency) {
		this.currency = currency;
	}

	public String getCustomerCode() {
		return this.customerCode;
	}

	public void setCustomerCode(String customerCode) {
		this.customerCode = customerCode;
	}

	public String getDescription() {
		return this.description;
	}

	public void setDescription(String description) {
		this.description = description;
	}

	public String getExchangeRate() {
		return this.exchangeRate;
	}

	public void setExchangeRate(String exchangeRate) {
		this.exchangeRate = exchangeRate;
	}

	public String getExtRefKey() {
		return this.extRefKey;
	}

	public void setExtRefKey(String extRefKey) {
		this.extRefKey = extRefKey;
	}

	public String getExtRefNo() {
		return this.extRefNo;
	}

	public void setExtRefNo(String extRefNo) {
		this.extRefNo = extRefNo;
	}

	public String getFullPartialFlag() {
		return this.fullPartialFlag;
	}

	public void setFullPartialFlag(String fullPartialFlag) {
		this.fullPartialFlag = fullPartialFlag;
	}

	public String getInstanceNo() {
		return this.instanceNo;
	}

	public void setInstanceNo(String instanceNo) {
		this.instanceNo = instanceNo;
	}

	public String getInvoiceRefDate() {
		return this.invoiceRefDate;
	}

	public void setInvoiceRefDate(String invoiceRefDate) {
		this.invoiceRefDate = invoiceRefDate;
	}

	public String getInvoiceRefNo() {
		return this.invoiceRefNo;
	}

	public void setInvoiceRefNo(String invoiceRefNo) {
		this.invoiceRefNo = invoiceRefNo;
	}

	public String getIsactive() {
		return this.isactive;
	}

	public void setIsactive(String isactive) {
		this.isactive = isactive;
	}

	public String getIssync() {
		return this.issync;
	}

	public void setIssync(String issync) {
		this.issync = issync;
	}

	public String getMsgActResult() {
		return this.msgActResult;
	}

	public void setMsgActResult(String msgActResult) {
		this.msgActResult = msgActResult;
	}

	public String getMsgAltDesc() {
		return this.msgAltDesc;
	}

	public void setMsgAltDesc(String msgAltDesc) {
		this.msgAltDesc = msgAltDesc;
	}

	public String getMsgCode() {
		return this.msgCode;
	}

	public void setMsgCode(String msgCode) {
		this.msgCode = msgCode;
	}

	public String getMsgDesc() {
		return this.msgDesc;
	}

	public void setMsgDesc(String msgDesc) {
		this.msgDesc = msgDesc;
	}

	public String getCustomerName() {
		return this.customerName;
	}

	public void setCustomerName(String customerName) {
		this.customerName = customerName;
	}

	public String getProject() {
		return this.project;
	}

	public void setProject(String project) {
		this.project = project;
	}

	public String getReceiptDocNo() {
		return this.receiptDocNo;
	}

	public void setReceiptDocNo(String receiptDocNo) {
		this.receiptDocNo = receiptDocNo;
	}

	public String getReceivedType() {
		return this.receivedType;
	}

	public void setReceivedType(String receivedType) {
		this.receivedType = receivedType;
	}

	public String getRefDocument() {
		return this.refDocument;
	}

	public void setRefDocument(String refDocument) {
		this.refDocument = refDocument;
	}

	public String getRemarks() {
		return this.remarks;
	}

	public void setRemarks(String remarks) {
		this.remarks = remarks;
	}

	public String getSapCompanyCode() {
		return this.sapCompanyCode;
	}

	public void setSapCompanyCode(String sapCompanyCode) {
		this.sapCompanyCode = sapCompanyCode;
	}

	public String getSapPlantCode() {
		return this.sapPlantCode;
	}

	public void setSapPlantCode(String sapPlantCode) {
		this.sapPlantCode = sapPlantCode;
	}

	public String getServiceVatFlag() {
		return this.serviceVatFlag;
	}

	public void setServiceVatFlag(String serviceVatFlag) {
		this.serviceVatFlag = serviceVatFlag;
	}

	public String getSyncCreatedby() {
		return this.syncCreatedby;
	}

	public void setSyncCreatedby(String syncCreatedby) {
		this.syncCreatedby = syncCreatedby;
	}

	public Date getSyncCreatedon() {
		return this.syncCreatedon;
	}

	public void setSyncCreatedon(Date syncCreatedon) {
		this.syncCreatedon = syncCreatedon;
	}

	public String getSyncUpdatedby() {
		return this.syncUpdatedby;
	}

	public void setSyncUpdatedby(String syncUpdatedby) {
		this.syncUpdatedby = syncUpdatedby;
	}

	public Date getSyncUpdatedon() {
		return this.syncUpdatedon;
	}

	public void setSyncUpdatedon(Date syncUpdatedon) {
		this.syncUpdatedon = syncUpdatedon;
	}

	public String getTaxTypeCode() {
		return this.taxTypeCode;
	}

	public void setTaxTypeCode(String taxTypeCode) {
		this.taxTypeCode = taxTypeCode;
	}

	public String getUnitNumber() {
		return this.unitNumber;
	}

	public void setUnitNumber(String unitNumber) {
		this.unitNumber = unitNumber;
	}

	public String getUpdatedBy() {
		return this.updatedBy;
	}

	public void setUpdatedBy(String updatedBy) {
		this.updatedBy = updatedBy;
	}

	public String getUpdatedOn() {
		return this.updatedOn;
	}

	public void setUpdatedOn(String updatedOn) {
		this.updatedOn = updatedOn;
	}

	public String getVatBaseReceived() {
		return this.vatBaseReceived;
	}

	public void setVatBaseReceived(String vatBaseReceived) {
		this.vatBaseReceived = vatBaseReceived;
	}

	public String getVatCode() {
		return this.vatCode;
	}

	public void setVatCode(String vatCode) {
		this.vatCode = vatCode;
	}

	public String getVatReceived() {
		return this.vatReceived;
	}

	public void setVatReceived(String vatReceived) {
		this.vatReceived = vatReceived;
	}

	public String getVoucherDate() {
		return this.voucherDate;
	}

	public void setVoucherDate(String voucherDate) {
		this.voucherDate = voucherDate;
	}

	public String getWhtAmount() {
		return this.whtAmount;
	}

	public void setWhtAmount(String whtAmount) {
		this.whtAmount = whtAmount;
	}

	public String getWhtBaseAmount() {
		return this.whtBaseAmount;
	}

	public void setWhtBaseAmount(String whtBaseAmount) {
		this.whtBaseAmount = whtBaseAmount;
	}

}